SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418804 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418804 [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120900,554066,340428,309032,518796,183342,832710,414245,721399,903056,858300,488786,145296,792618,927336,393108,40830,996651,238269,272549,894141,834107,130311,590744,578029,1015019,322808,169442,247244,222187,790648,624924,431450,931230,772014,1020481,943694,304213,795330,651008,720765,455113,991095,533459,1007079,805468,417162,6559,822630,816016,429333,693645,284296,342502,827370,425331,968794,403399,201525,494220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000753s ]