SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524418 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524418 [ RunTime:0.002418s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184323,268661,97635,66389,572538,17060,850116,768744,466095,882133,25613,801857,302927,538831,844725,406829,306017,883130,372500,321962,748005,280751,355130,78121,1047046,845740,620157,138543,539999,589844,439770,1028783,486441,167854,620435,1014504,165411,232838,243679,241851,278800,289354,1046086,432757,710931,392788,883683,366608,945933,632988,571112,295205,836862,18042,797806,853671,738721,239260,563432,418303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000763s ]