SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404088 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404088 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611846,270235,45609,593121,580524,793909,333537,309576,303474,485211,474644,612513,543359,80828,1034345,92327,331109,451964,784093,725806,133619,296924,250184,248183,232530,764725,1036836,34263,713292,698863,78385,1038589,88857,346590,85468,881644,12239,748873,793360,608234,28740,999262,189012,248273,122295,101940,105653,564619,98660,577637,647847,919000,455859,100949,807192,724767,209949,634529,784419,632971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404088 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404088 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]