SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001489s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409238 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409238 [ RunTime:0.002039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (985523,396466,688243,810951,440729,509775,771711,708727,919536,344354,926766,788054,289170,734653,212025,57112,83630,279170,463063,122584,543606,786536,190567,237797,879404,784571,439583,989543,838997,742411,337712,515655,395612,303577,257012,299416,738261,564835,188993,686914,171665,258847,117962,47285,106027,372215,681512,111739,18262,881597,279923,204508,608563,188754,558558,943060,621851,754710,823334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000643s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]