SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002515s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521115 LIMIT 1 [ RunTime:0.002420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521115 [ RunTime:0.004697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801248,431076,916452,360026,452018,514759,379048,919128,564892,374221,12130,56168,257251,838222,982452,988081,488118,309176,592198,592361,258201,756699,570145,47725,424468,974885,145591,727734,321926,180086,13094,336886,528433,463556,548063,527195,613297,460903,956862,464674,43701,137676,559157,245154,608890,491534,616780,8040,217872,522032,606899,967402,510405,502388,793558,11599,289184,12561,1040024,472631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002857s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521115 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521115 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000757s ]