SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28134 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28134 [ RunTime:0.002173s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715485,895807,694223,665944,116528,288142,938945,661287,534348,886650,968853,83110,313627,121498,514334,784611,560588,490081,730113,826242,799365,69802,762310,304452,132485,1020837,464717,988318,596991,729130,221109,353312,12850,893873,458509,687121,118352,497525,379753,687060,83339,410722,988463,161337,554472,615028,510644,131165,34922,264577,885665,394147,814963,50912,636229,733185,254399,778627,364521,711700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28134 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28134 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]