SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535508 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535508 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (77605,361776,847560,690143,130218,974700,983371,800144,118733,131805,491577,501927,109527,413640,910314,562720,910685,510587,883641,838307,919297,741729,270102,337763,1040418,794950,892151,325274,451313,212924,145417,667256,490085,910648,136922,902440,326631,29980,710527,268010,575854,305954,664246,581423,809763,35067,150329,328937,1010640,200,24850,127801,1013571,398654,419167,865363,868526,980095,718752,58306) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]