SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319862 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319862 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (36197,1003636,599719,1047005,689342,676901,353288,742360,428082,523270,576472,1003824,287162,24402,927339,496186,674333,16716,17083,197237,35695,713985,501631,118473,491103,522947,341910,664441,525415,87785,126834,799987,432687,725869,177777,197956,23091,618260,566140,240390,324549,465448,998399,569398,163718,512025,512446,807045,866079,38569,1033999,369804,711631,353724,947919,518591,493878,856865,878279,92277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001569s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319862 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319862 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]