SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 74778 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 74778 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937796,1044224,486297,727157,404188,198111,248843,794371,202313,451590,453226,782084,802509,403025,716685,32968,851028,522416,443490,291973,170118,301058,271211,837769,789076,1032878,35666,996886,842885,924352,667305,808745,103720,838624,354922,839634,209658,871389,12719,39875,547929,1028664,14442,442914,434568,718723,233183,686785,232720,708447,315451,99000,825750,166989,389064,986271,511216,212657,906414,190973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 74778 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 74778 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]