SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331016 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331016 [ RunTime:0.002419s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804917,797095,192478,1001915,711528,957485,852795,924865,998493,920761,678585,890103,919649,450117,549608,1044923,85461,521022,695287,295617,161560,323571,1019641,167445,286865,911754,918595,438257,386387,914241,280315,599071,606946,45559,142031,811234,1013354,606770,291304,974769,917552,252813,468537,377703,726731,817281,394051,737431,891640,220413,240457,456316,499922,921070,552004,340913,192846,771321,878270,373607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]