SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023315 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023315 [ RunTime:0.003328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (762572,264091,120035,519147,157185,878399,605326,118648,860446,725270,93792,9137,291873,131908,636929,925552,387514,111650,899998,441619,1044943,47920,172475,822790,367213,872320,42748,742416,382534,531881,554360,37306,823173,604393,145013,602485,386887,908979,1006122,107779,412819,112148,248304,608979,608566,646332,157717,124281,683870,1016572,475222,144516,778357,490106,514839,368299,429182,375384,607067,417593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000845s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002219s ]