SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 842612 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 842612 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (139699,60766,982932,598921,813985,354992,352093,746511,924313,1032940,364087,947922,746843,1028180,415726,675132,450989,147425,900477,175959,883249,781161,1003445,471905,873461,148924,930764,456657,503037,622736,347567,11711,1039276,561294,405252,482452,98479,468159,274410,592640,523820,1036338,942237,260686,449420,641852,1015191,852127,212276,696273,74949,576471,709188,386669,758085,963920,888755,266233,602221,331121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 842612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 842612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]