SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305146 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305146 [ RunTime:0.002185s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160780,555984,357329,261022,443643,256136,790499,399315,178207,967225,779341,875118,978833,195534,801794,211409,749995,433913,555722,25408,959332,374050,743631,791275,749696,743149,25019,322806,351563,626651,608897,290791,84201,504736,858422,374784,299209,775319,177525,909876,680864,601436,802092,641597,644089,919508,773478,566128,441912,412225,783332,774816,455618,622449,629812,138445,457250,643843,828696,603003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305146 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305146 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]