SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 844713 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 844713 [ RunTime:0.002883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265454,695830,600231,360378,435006,904145,663499,779997,339953,388196,111132,39938,551382,1020355,939896,892718,634005,439583,556736,215419,240296,1033254,850020,666040,1024537,689397,1019332,402154,801762,589079,691131,824780,158420,891333,608869,819677,242808,602505,175682,791515,954779,737711,191054,689835,922340,269192,490377,226410,874742,590438,856282,737814,12445,276298,821977,962244,752931,426088,530812,940146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 844713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 844713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]