SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200969 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200969 [ RunTime:0.004049s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (849136,287468,112100,216313,119463,837671,633017,608794,456328,1024633,851483,144056,613195,331160,3981,770662,74214,939100,911201,902616,862686,126833,731282,108132,611960,983720,960337,674862,420713,394618,677513,73903,869908,90794,976747,858042,605118,393301,754757,941283,695791,198078,838765,807567,119830,195881,903883,759211,923487,686128,615276,1024949,308904,447169,845425,514252,1015745,651260,498515,502348) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200969 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200969 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002978s ]