SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001503s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017521 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017521 [ RunTime:0.001704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565124,1005457,135304,125983,115660,617656,138103,46576,625074,577495,655020,588833,712827,953527,480815,378648,141295,108516,16690,311994,25607,546459,230232,231364,328674,499965,830529,23831,637326,603239,377017,605853,905631,979598,731102,456032,947649,896218,152449,789806,795413,277374,17179,395938,800354,897623,471766,483173,267408,1005782,279858,183795,834894,299312,905457,744271,918436,997566,860175,205709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]