SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003470s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438760 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438760 [ RunTime:0.005035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415084,101096,794306,670328,302442,365677,537616,925177,20995,956563,889201,421989,550401,240022,336277,1020769,93524,896688,586771,986541,959848,45544,443249,492183,324449,641968,686245,328411,949526,499697,715087,799142,564011,744989,1036903,949252,1028412,580096,848068,95416,832687,165247,47537,416641,13967,526746,1032952,209171,1025973,917381,636476,460111,729291,703204,648848,826631,904580,71240,860193,77905) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000900s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000870s ]