SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412641 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412641 [ RunTime:0.004801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839221,503077,70832,334905,794829,1033334,132859,606571,431580,613472,465072,471086,955497,484443,945157,560810,883183,58162,643760,59763,96567,1006788,753043,226172,873752,470026,842537,721688,1024451,192007,716036,415720,226616,637633,598562,28527,891915,352132,845603,547606,571809,212367,991213,461437,835756,73919,858885,484884,255745,48032,530795,688140,345689,916377,150372,406609,771612,395803,205965,744777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]