SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10513 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10513 [ RunTime:0.002614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517474,865184,324137,1006673,568696,186749,574171,288335,557010,314463,838743,314868,678091,953611,117092,946542,245447,1039224,597536,56208,355554,517710,130612,574355,297045,967541,299208,496119,226016,670537,75950,70553,882247,961266,605950,638514,656468,393456,730738,645084,94205,355203,361625,479754,731963,675200,131845,486179,722901,170788,463080,252989,667453,378196,328180,14616,927747,895354,101191,854779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]