SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 235203 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 235203 [ RunTime:0.002025s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (360015,600559,536139,604915,336007,986358,501745,489513,617862,4272,588848,525398,1018704,588448,441907,478442,144226,680450,560814,7530,641657,723812,208407,236144,994361,912316,456455,713500,69169,1048098,759270,16585,1001298,668851,582989,104144,151507,438913,1009697,464713,371837,638342,111467,103240,841656,873604,184406,573091,891538,644169,229177,860461,728849,385108,649696,591945,811459,392382,55013,796376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 235203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 235203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001567s ]