SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525532 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525532 [ RunTime:0.002670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445004,72827,568739,257028,306701,655743,477168,600227,994650,381623,618471,332621,932088,73290,262611,51774,240006,72449,76783,3996,96425,582093,919966,45146,341052,418792,436846,81984,919076,502346,137353,96122,991632,607389,61730,581070,768507,17887,4125,924324,555269,404499,115208,40617,716446,460341,15135,951405,715706,762115,514198,763176,564903,894407,857903,757787,3365,999810,157100,246614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525532 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525532 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]