SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515429 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515429 [ RunTime:0.002254s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (90213,31148,273261,834366,126369,155951,610432,6738,902501,902435,250183,379153,803752,956774,893860,858115,675378,656589,381178,25674,691514,246940,852178,1041196,182623,1008412,314902,276475,75162,419217,454887,204446,290766,850013,845991,63207,814038,131920,355821,460617,971580,671487,382286,923500,972271,971696,646231,624327,901708,817594,325617,683572,765923,938405,769210,158938,683055,938891,812980,807864) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]