SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840501 LIMIT 1 [ RunTime:0.002772s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840501 [ RunTime:0.006705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689050,534928,1030605,75277,746118,572148,568665,379705,859931,629965,315953,249233,273471,672157,960702,730361,176438,163839,427554,93777,791519,993613,857142,77386,667347,790912,193880,50563,929739,169964,1029729,17942,379316,304018,671390,778709,244515,181123,129429,251289,995856,412579,389734,868384,350188,24049,497861,875512,666744,643137,150357,924858,596865,988302,969992,435455,413869,81508,681475,505424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001875s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001181s ]