SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455464 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455464 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041518,274407,1034237,290840,369143,433424,235753,476843,160566,820109,55174,345952,1002464,1015425,953642,660463,554512,28838,237708,670616,144296,298716,149115,45591,293194,290709,538041,839840,14569,862944,1005440,823292,535283,754216,961198,336833,549285,738658,668898,92514,951070,1047588,314089,474943,593722,1000291,598988,878061,1005783,230763,276928,257637,242119,816985,649959,286182,444040,485244,806692,776520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455464 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455464 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000738s ]