SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400787 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400787 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930148,531822,573666,896202,946352,408389,78673,359544,709377,459614,314662,791932,1018650,102189,120227,845741,211256,283777,875601,608037,204814,278004,829751,665140,428468,1002588,1017232,244989,344454,718877,14581,830522,102223,110444,208034,1005948,266056,180883,148980,992350,255665,923337,390629,623987,207441,446169,653777,742430,168493,905590,57936,591207,1008580,14531,328425,879163,774697,263796,97154,850587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400787 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400787 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]