SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001523s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4101 LIMIT 1 [ RunTime:0.001126s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4101 [ RunTime:0.006976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328688,789960,267859,1004574,584660,408579,37005,544618,137935,436153,187924,876088,570919,690371,566263,820978,378234,48130,153904,681409,705244,777187,901042,395591,735312,876234,424484,75092,966626,545555,126315,461959,382560,86314,249445,83729,507714,286699,329018,263111,622026,542014,478753,90951,360736,328929,727033,477541,855118,453712,64648,230088,322739,134080,105377,513049,415877,130823,550096,887051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001995s ]