SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002564s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457440 LIMIT 1 [ RunTime:0.000481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457440 [ RunTime:0.002111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (727257,750510,926397,790373,11796,462328,858249,987056,119800,803083,609683,298548,883620,185220,391524,567135,729910,1037728,911699,403942,778405,819564,596986,614490,797432,87550,986778,917463,946267,220579,240077,547920,132866,775513,828841,482223,495421,894870,90217,122044,921767,124315,659292,506402,972133,122601,31910,125069,892139,548034,883727,1016866,549848,287536,198767,187111,1014540,852878,130360,319720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]