SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506895 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506895 [ RunTime:0.005832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348420,891586,635626,1047585,158216,775863,320410,312340,81593,545423,731689,249291,151946,186691,201522,555258,97188,96803,794074,22473,577577,60370,570827,234099,545769,550356,79800,155064,212263,794308,540128,7138,197237,1048164,337404,94478,670982,487034,824840,507983,292781,431991,810788,464890,305277,438164,888913,609271,948258,737878,821567,65087,56210,273378,607806,267896,445532,235227,668586,819075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506895 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506895 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]