SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 987618 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 987618 [ RunTime:0.003882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640244,152001,122382,320178,385127,276942,321158,419864,345813,4880,698411,697234,999647,599405,999378,599145,410335,403932,861896,50777,927698,21439,14498,210448,1037660,765875,874291,581034,966263,423554,233118,1032831,412009,343705,263369,133714,167822,603207,1015430,794359,192126,321026,927554,205490,838256,1033420,364077,332860,149052,837720,839853,390114,803214,97070,1031931,673447,916628,99565,812466,336503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 987618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 987618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]