SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 180640 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 180640 [ RunTime:0.002678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444024,358562,373740,287769,928692,1007447,399991,893102,888673,341732,338695,78191,396360,278665,513416,339801,171857,49795,310858,155037,56891,607609,1006703,212693,1035039,398951,702245,176402,694818,307287,458652,857598,381727,7333,435617,184889,841593,898963,234101,991686,938185,643379,108383,445553,676922,153766,976226,823161,870679,116752,87266,259931,60573,607897,114943,572008,589328,381387,86067,331659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 180640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 180640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]