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` = 417581 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417581 [ RunTime:0.002899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252306,443107,5722,365296,516254,52693,695204,8003,314904,807597,488215,345193,439833,84429,844149,189138,514181,660930,276155,805079,185880,296271,625062,438313,730783,726730,524092,112990,219418,143378,352659,101531,533799,258254,1033669,220360,863703,69698,340926,239325,849498,193976,733986,46484,1004439,377171,184817,96330,263485,757826,322569,624685,102343,513947,912048,707690,930980,558302,868073,220484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]