SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001643s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474513 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474513 [ RunTime:0.001814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628639,849059,524252,944340,1011434,250591,130637,369189,100156,515021,558636,353132,521845,687383,492205,958463,117303,398095,530482,167750,1021555,779872,77591,941511,517851,91727,112803,12491,726867,586522,434539,409036,477610,679657,460277,122782,738800,739135,680076,549819,673505,748121,997004,846932,594269,956300,998478,855897,259834,738252,619099,108937,388004,177417,201702,1012858,25499,617369,107924,444364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]