SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039804 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039804 [ RunTime:0.003165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701636,450205,305837,518550,65920,768517,710492,411761,1026662,702332,633518,765372,98825,955083,478148,271417,637046,299962,728404,347620,91346,542249,764269,560772,711477,894877,232498,119820,966961,763324,521363,299504,947947,102101,962527,300387,950850,626568,403511,1033882,1021162,302113,558846,376817,855399,210436,205599,293858,1034896,359835,765572,72215,452653,400514,600135,342181,770992,307814,783293,824133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]