SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 365798 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 365798 [ RunTime:0.002285s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106577,692086,334,825556,992404,870140,209406,89610,1026858,56535,905472,481005,282413,342957,583406,476652,442979,134688,567185,168523,746067,1031728,440916,734626,722914,330276,626134,743640,95890,789313,614397,761219,47884,140182,702211,876046,1004740,399238,737319,314470,768212,1029157,597016,1024700,604702,342425,824932,686296,157277,551022,627631,939243,799435,122327,1040651,851129,37452,338531,297673,847374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 365798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 365798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]