SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413361 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413361 [ RunTime:0.002179s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (637851,651934,427432,824055,732644,727930,21604,749934,489852,1033073,473749,105845,132572,779560,711630,113661,844997,314247,652310,616251,359312,671949,383598,565242,934804,328664,469935,633631,991351,38460,242539,362662,521719,105161,296923,354197,753844,546728,720831,647981,325786,546495,204477,100189,540831,198060,977933,522365,572981,1001239,536136,870429,485727,922443,950512,366554,235750,573118,99190,1044494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413361 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413361 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]