SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515540 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515540 [ RunTime:0.003385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664771,901309,677654,48253,915875,262955,254622,1006535,800135,346565,554922,942800,411187,41158,335557,888238,298227,729287,423255,568208,943238,390079,334122,208947,214013,792024,133449,1035528,764226,43140,957358,433020,1013125,487658,1041270,394947,48110,791511,602455,940227,110889,175912,537780,675255,706941,252250,47813,679888,890006,392929,514895,562456,1036880,12594,885883,435055,276740,30127,401487,411720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002399s ]