SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109480 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109480 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252049,953734,997792,176876,947319,31372,244966,813177,347337,736651,931872,742853,996053,712767,243113,945047,9665,1000084,720967,647802,421432,21518,677547,890328,85450,129629,931730,142104,135791,697314,354487,1040810,138940,457210,157238,841554,782704,744242,1048352,498483,314581,705030,474528,327705,354570,37421,557190,569282,509145,585550,399131,580012,701234,842817,988210,551656,842882,1023255,401270,970532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]