SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104917 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104917 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048604,435776,153877,635056,129998,586151,1006406,788922,452895,799352,886479,770947,679904,330014,787736,603731,164032,14645,548370,606242,374555,41512,416600,12000,860166,856214,403663,25134,811369,477154,632226,530062,725535,114441,816952,328744,954558,907520,95065,374132,894580,739525,487916,139200,71428,733835,869318,672152,400984,97403,468292,311160,300272,613768,458101,996525,1028687,644958,902896,754103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]