SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50460 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50460 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219644,203109,991153,263873,28831,20113,905574,829883,182022,592606,835986,893633,819957,743700,982320,39169,553141,621006,73187,530793,109782,343638,772500,297777,926328,617071,1039141,371615,427884,53640,18161,180880,600123,821091,446665,17672,1029244,254682,406009,232893,941379,181452,859602,107752,458104,946285,167018,234084,427456,136204,249681,101604,914327,609720,13198,379798,599935,205948,885078,904411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]