SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002718s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 791043 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 791043 [ RunTime:0.004684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (297332,671220,555830,498955,609068,143799,708369,442446,226010,369185,150801,903455,22411,25817,981570,132466,444863,831866,863274,769387,77522,345000,663469,526586,860321,752825,254402,453124,348988,139289,978131,481191,70428,241474,233270,148174,566602,320812,547057,955432,465098,984436,498676,29611,970302,452091,669786,116290,872643,1013123,273733,5828,515052,355765,926682,438926,399734,663034,175602,154834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 791043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 791043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]