SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002552s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542580 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542580 [ RunTime:0.001904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452690,898636,246123,222999,937630,274671,809412,515275,286958,1019949,292925,922689,953201,962589,959257,22470,1048244,970647,739121,823853,303827,861596,705502,421150,375216,290090,399783,867205,17631,707564,713270,109591,180691,732442,821841,378995,428804,984456,193578,773197,809469,855742,383788,706090,561557,405644,434947,917927,976334,720349,993405,102724,93953,266116,767638,844072,478902,934832,796443,177318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]