SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510860 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510860 [ RunTime:0.001932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (997833,953141,881844,170952,392891,164256,956353,319262,92008,839997,329791,407116,134443,820383,732457,123161,59346,57054,725241,400268,613677,1045120,985602,539484,601517,4540,547757,548218,454273,200787,291579,96380,859958,288818,428596,730469,748026,375925,773783,164140,826584,1039627,523172,282519,16072,132742,351243,953709,972083,939223,469191,23423,658660,665789,432762,166044,76809,897895,71270,932972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]