SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015917 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015917 [ RunTime:0.005580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250855,653235,883915,251467,153899,198754,707263,768142,837037,199790,438622,50067,184311,39974,120817,280029,1045679,100300,37508,516593,455412,357553,704679,267424,79158,620377,287380,897673,514037,220096,519138,92147,318233,498643,616573,774340,518107,148493,206452,76300,825206,56798,767131,372287,394440,725143,869874,575205,1045396,15982,455098,451107,797745,150162,453989,254642,941737,19599,497834,597181) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]