SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 363983 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 363983 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187278,926513,1040508,628646,352267,876513,402616,209949,987902,468524,1009514,569771,796828,324701,817264,899102,803279,1011104,224108,937285,203300,404424,267197,780801,330119,85113,886218,955457,685319,315648,931564,255151,1023773,239444,641212,407156,292845,110681,326142,544653,7306,345579,441777,366599,4442,572340,401399,1027759,128141,385986,317707,847200,478368,448917,755607,590937,666017,8627,564973,851000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 363983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 363983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]