SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405688 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405688 [ RunTime:0.001494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28230,996235,532113,654968,1896,615687,823552,1016732,742507,970461,467833,174503,965165,576861,955957,612690,70683,952271,326695,341631,711616,146019,463172,847825,253087,862537,742044,388154,496144,73004,72605,705272,153663,581553,670694,443733,888310,667197,495441,966245,491082,555865,11989,792668,570880,140710,1037615,207566,972256,16250,153201,113857,920646,211214,246173,80842,289859,460420,282749,464159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]