SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 159812 LIMIT 1 [ RunTime:0.001176s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 159812 [ RunTime:0.003037s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046172,915661,294902,475257,1042780,724562,799077,562100,1015351,46517,782169,295259,702530,451951,397440,777270,214659,495537,285540,1028243,429988,883796,187187,230948,793975,368472,626251,63362,412350,394162,873581,134771,73323,22726,814330,734234,935773,954626,351126,586255,113559,390671,149355,652138,964424,354810,1012024,186027,306725,507766,20869,517849,86870,61699,652970,819000,10865,486001,409282,725246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 159812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 159812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002975s ]