SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50158 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50158 [ RunTime:0.002010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604686,151677,350554,813192,921254,613537,661826,162454,359603,666059,106381,526635,10200,552963,474566,1034702,758707,536251,899792,538870,336286,166379,248637,846974,784506,886071,316567,364159,380961,287695,291434,677143,18250,665578,957238,566126,1020752,608468,287909,664164,344866,342735,960213,905780,91720,29683,1021564,987210,1037598,579394,295851,808355,551110,570299,727990,623505,56245,176720,894105,942597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]