SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336108 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336108 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280127,136122,805970,484345,634096,903098,602306,757851,742826,506902,664017,479513,632177,432583,838394,950566,201587,796312,101585,1015094,767427,541629,257386,867293,110876,701216,818230,182902,824394,168836,125171,11436,278631,58900,240363,447934,31745,977208,1024530,890607,567500,815181,786643,601219,625909,87923,972189,166151,616524,676246,612934,162183,422675,903672,243811,1034430,263503,670504,498808,17836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]