SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535099 LIMIT 1 [ RunTime:0.000779s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535099 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (716459,256107,274751,883135,737218,91810,841795,159190,714480,699942,91663,190132,502908,773534,10143,45208,921002,86590,223617,1022186,1009635,954089,761236,101472,623344,145615,839968,879232,827765,551254,366244,449040,386499,462460,348349,890884,834579,508892,759263,234716,850987,982121,437567,112690,847669,881446,199434,877207,516635,505797,214458,594576,795469,204074,296875,580540,864536,603170,164790,276115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000653s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]