SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49782 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49782 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040281,2012,516174,863250,255822,24412,708614,992692,478673,747693,530180,915625,662162,850022,68629,539357,7285,656598,751152,361720,333360,602756,690468,336497,111266,753267,552464,1010748,803446,387041,210805,891245,298013,771886,727858,241658,802784,289601,579652,974018,402212,815579,741725,120669,24545,243101,556804,111101,130346,861231,558434,826397,73139,596938,362135,175027,536334,653363,935761,552314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49782 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49782 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]