SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421112 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421112 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868602,3750,114222,487971,960246,430601,789166,668882,447512,867833,104000,388463,351515,627796,668491,504081,1007935,69859,28955,67022,806838,886897,848861,139154,245220,17674,548855,39612,826943,989469,799366,14157,629620,987724,36236,827876,321228,568201,694245,271307,1007103,971813,866140,193020,975783,848339,448763,643598,6297,601120,669965,121464,636062,703377,405664,508795,892292,157304,431151,207849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]