SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001866s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 146013 LIMIT 1 [ RunTime:0.001018s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 146013 [ RunTime:0.003510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (962354,999685,31358,861627,326445,735240,539425,611521,333003,730477,381118,826714,198689,859769,921245,255103,194918,715307,976322,976242,768869,1000311,1011486,189384,512306,135552,124761,603518,615925,494252,739314,192528,809682,371985,2534,810134,573912,163125,592219,355799,658154,600547,1039527,375817,916376,7348,878953,836238,48973,480016,281139,695082,669357,397522,212228,119760,692650,472973,773210,1009189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 146013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 146013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]