SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543805 LIMIT 1 [ RunTime:0.002512s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543805 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017669,742805,658351,140376,999916,452060,776191,909665,999184,37010,176892,111313,340813,796697,20616,207983,118802,951203,970912,689939,855789,442741,904752,106469,631340,672672,805266,443879,921015,219049,924850,118234,674707,440294,335431,621870,885814,249761,775469,823080,179081,169492,944365,710583,1003555,976906,124625,401543,1045667,623100,152126,780226,596381,586147,1007199,48305,935464,284372,550915,686628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002922s ]