SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003798s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500314 LIMIT 1 [ RunTime:0.001790s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500314 [ RunTime:0.007198s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582369,654718,775204,642549,692318,628784,336407,734626,341600,265287,433672,115690,1035648,626276,407571,274313,208599,401258,1036302,849622,883914,737886,652728,246028,509776,256296,934648,803431,96229,874426,291479,467080,917365,309959,102023,726161,269098,1000383,684011,632899,441640,401528,44903,254694,353405,229542,883188,302124,592575,581420,319851,465786,11757,593417,264768,305555,521312,299019,313033,527206) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003286s ]