SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501183 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501183 [ RunTime:0.002959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (241989,998034,9722,376369,1020126,1035192,594912,52515,395409,1003489,955053,3297,4423,794414,93066,249882,138703,281991,413936,388150,961396,718201,416180,858258,876854,856192,674140,956250,819443,255575,656000,110409,442271,425886,478423,215094,959637,342522,670410,950886,1017503,940256,5598,165826,487062,792919,140035,115637,851487,127863,613015,615298,38386,379816,906266,645712,715784,812101,482534,994738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]