SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021418 LIMIT 1 [ RunTime:0.001966s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021418 [ RunTime:0.005397s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036057,707969,740789,551973,1041455,484563,116062,676314,742218,668475,853456,137082,979147,502811,753258,39838,974780,890384,598855,832009,434608,756316,767244,533567,319067,105027,378747,48939,661430,239129,954105,541683,894508,1003220,65406,265401,311923,559967,61189,852794,318622,496611,633097,73653,769714,261508,402951,522518,41150,240326,75524,45864,281487,70036,167675,944507,1011444,987543,334544,984852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]