SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567894 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567894 [ RunTime:0.001785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991467,351088,187241,449822,802484,344150,84702,839360,1014336,876813,670673,199893,616646,44965,946202,233071,737416,660636,542405,797163,517727,698163,952659,491096,620235,200064,870834,638251,510806,501056,2876,477006,208316,238452,728202,983775,607610,897229,819406,1034208,884298,1044039,66294,167710,67330,721567,424712,387880,438086,189135,628124,230154,653468,896014,405081,411370,551651,325642,54820,937258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]