SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392791 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392791 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541189,855357,995986,887078,616317,718467,166777,998225,882076,71668,304592,388544,42462,443363,190443,846165,705318,673766,235725,361978,569137,964400,160946,863091,509137,752386,294278,463060,160169,348439,122027,355465,1009187,481711,297405,1023346,788353,166333,793550,869445,825547,307148,117779,98083,959345,341900,690914,840626,804396,386906,43583,1011415,179595,809745,60254,140791,847937,591735,129937,1007732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]