SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553710 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553710 [ RunTime:0.001462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939218,740589,526430,990466,305731,510800,532609,590220,862493,900042,578882,599806,127847,337386,270607,764058,504344,911141,1022738,143587,72004,477942,402772,654343,647844,935831,682695,971348,197931,613479,232649,696235,929369,138239,917851,491112,678975,557954,704076,704200,108789,571096,1017916,285320,1022440,235054,759683,590826,357794,85569,883717,956109,216416,39899,338158,1030076,8850,213440,663924,167478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]