SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345193 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345193 [ RunTime:0.001925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890778,385942,203796,612001,690049,431027,1042529,638764,1020605,254297,767079,791129,852514,811916,135519,122498,651961,498128,204586,172867,617569,739489,938081,191465,408797,704654,302162,747677,761801,757140,90573,450877,1025259,435027,422160,618489,833151,508670,1006361,870886,143115,894239,479861,102894,282230,957416,74165,404253,997479,15432,673981,23487,154984,278848,566017,579235,199855,26991,691664,136106) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]