SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004793s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541099 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541099 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314510,518817,419324,623058,673317,328766,744159,258517,591003,486855,302954,873708,424682,782782,47639,1007198,50906,327601,460727,674097,808905,304795,505692,728053,175260,130227,1032750,640770,325719,500517,90282,357168,377004,641546,932895,102492,577409,231562,764650,234582,692931,364034,544963,162011,687638,445069,418441,1006264,365433,346657,263002,842269,10713,430706,733987,142003,13131,589683,979355,375833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]