SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 675283 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 675283 [ RunTime:0.003378s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285907,428210,375506,724964,605080,748463,137388,13855,173691,476054,910390,688208,702066,252793,845028,38057,330588,819812,997208,32315,123236,1030058,355933,311402,299795,702791,803846,325265,345753,7142,739021,962888,976555,362658,979133,353110,382621,917861,146744,166681,122429,919153,232095,880940,876114,245324,926716,332556,453352,412733,910137,628131,402080,815467,575400,155214,37335,1004750,659388,750170) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 675283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 675283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]